StudentPreviousEducation

EntityType | Independent
Logical Entity Name | StudentPreviousEducation
Default Table Name | AmProspectPrevEduc
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentPreviousEducation Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentId |  | INTEGER | YES |
CollegeId |  | INTEGER | YES |
Status |  | CHAR(1) | YES |
TranscriptRequestDate |  | DATETIME | YES |
FinancialAidTranscriptRequestDate |  | DATETIME | YES |
CreditsReq |  | MONEY(19, 4) | NO |
CreditsOK |  | MONEY(19, 4) | NO |
ModFlag |  | CHAR(1) | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | YES |
StudentPreviousEducationId |  | INTEGER | NO |
PreviousEducationId |  | INTEGER | YES |
GPA |  | NUMERIC(11, 6) | YES |
IsGraduated |  | BIT | NO |
GraduationSession |  | VARCHAR(10) | YES |
EnrollmentDate |  | DATETIME | YES |
GraduationDate |  | DATETIME | YES |
LastAttendedDate |  | DATETIME | YES |
StudentRank |  | INTEGER | YES |
SchoolSize |  | INTEGER | YES |
TranscriptType |  | TINYINT | YES |
DegreeiD |  | INTEGER | YES |
Major |  | VARCHAR(100) | YES |
TranscriptID |  | INTEGER | YES |
OtherCollege |  | VARCHAR(60) | YES |
GradeLevelId |  | INTEGER | YES |
HSGradYear |  | VARCHAR(4) | YES |
HighSchoolId |  | INTEGER | YES |
GEDAwardedDate |  | DATETIME | YES |
Note |  | VARCHAR(2000) | YES |
IsExcludedCrmIntegration |  | BIT | NO |
QualityPoints |  | NUMERIC(15, 6) | YES |
CreditHoursAttempted |  | NUMERIC(9, 2) | YES |
ClockHoursAttempted |  | NUMERIC(9, 2) | YES |
GradePoints |  | NUMERIC(9, 2) | YES |
CoursesTaken |  | INTEGER | YES |
ATBCode |  | CHAR(2) | YES |
ATBAdmin |  | CHAR(2) | YES |
ATBTest |  | CHAR(2) | YES |
ATBState |  | CHAR(2) | YES |
ATBDate |  | SMALLDATETIME | YES |
DegreeId |  | INTEGER | YES |
GradeLevelId |  | INTEGER | YES |
HighSchoolId |  | INTEGER | YES |
PreviousEducationId |  | INTEGER | YES |

StudentPreviousEducation Keys

Key Name | Key Type | Keys
AmProspectPrevEduc_AmHighSchoolID_N_N_IDX | Inversion Entry | HighSchoolId
AmProspectPrevEduc_AmGradeLevelID_N_N_IDX | Inversion Entry | GradeLevelId
AmProspectPrevEduc_AmPrevEducID_N_N_IDX | Inversion Entry | PreviousEducationId
AmProspectPrevEduc_AmProspectPrevEducID_U_C_IDX | PrimaryKey | StudentPreviousEducationId

StudentPreviousEducation Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
College | Non-Identifying | Zero or One to Zero or More |  |  |  | CollegeId | NO
Degree | Non-Identifying | Zero or One to Zero or More |  |  |  | DegreeId | NO
PreviousEducation | Non-Identifying | Zero or One to Zero or More |  |  |  | PreviousEducationId | NO
PreviousEducationGradeLevel | Non-Identifying | Zero or One to Zero or More |  |  |  | GradeLevelId | NO
HighSchool | Non-Identifying | Zero or One to Zero or More |  |  |  | HighSchoolId | NO
GradeLevel | Non-Identifying | Zero or One to Zero or More |  |  |  | GradeLevelId | NO
HighSchool | Non-Identifying | Zero or One to Zero or More |  |  |  | HighSchoolId | NO
PreviousEducation | Non-Identifying | Zero or One to Zero or More |  |  |  | PreviousEducationId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

StudentPreviousEducation Check Constraints

Check Constraint Name | CheckConstraint

StudentPreviousEducation Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentPreviousEducation | NO |  |  |
Physical (Microsoft SQL Server) dbo.AmProspectPrevEduc | NO |  |  |

StudentPreviousEducation Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | PreviousEd_TransferCredits
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Admissions

StudentPreviousEducation Data Movement Rules

Name | Type | Rule Text/Value